File manager - Edit - /home/autoph/public_html/projects/app/Http/Controllers/API/v1/SalaryAndWagesController.php
Back
<?php namespace App\Http\Controllers\API\v1; use App\Http\Controllers\Controller; use App\Models\Employee; use App\Models\SalaryAndWages; use Illuminate\Http\Request; use Illuminate\Http\Response; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Validator; use Throwable; class SalaryAndWagesController extends Controller { public function index(Request $request, $id) { } public function show(string $id) { $data = Employee::with([ 'position', 'salary_and_wages' ]) ->select(DB::raw("CONCAT(firstname, ' ', lastname) as full_name"), 'employees.*') ->where('employees.employee_id', '=', $id)->first(); return response()->json($data); } public function store(Request $request, string $employee_id) { $shieldsData = [ "tax" => $request->tax ? 1 : 0, "sss" => $request->sss ? 1 : 0, "pagibig" => $request->pagibig ? 1 : 0, "philhealth" => $request->philhealth ? 1 : 0 ]; $request['shields'] = json_encode($shieldsData); $employeeExists = SalaryAndWages::where('employee_id', $employee_id)->exists(); $validator = Validator::make($request->all(), [ 'salary_rate' => [ 'required', 'min:1', ], ]); if($employeeExists){ $data = SalaryAndWages::where('employee_id', $employee_id)->first(); if (!$data) { return response()->json(['messages' => 'No data found.'], 404); } /** If validation fails return with error message */ if ($validator->fails()) { $errors = $validator->errors(); $first = $errors->getMessages(); return response()->json([ 'status' => false, 'message' => (reset($first))[0], 'errors' => $errors ], Response::HTTP_UNPROCESSABLE_ENTITY); } DB::connection()->beginTransaction(); try { $data->fill($request->all()); $data->save(); $data->touch(); DB::connection()->commit(); return response()->json([ 'message' => 'Record Successfully updated!', 'status' => 'success', 'data' => $data, ], 201); } catch (Throwable $e) { DB::connection()->rollback(); return response()->json([ 'status' => false, 'message' => 'Unable to process request. Please try again.', 'data' => $e->getMessage() ]); } } else { /** If validation fails return with error message */ if ($validator->fails()) { $errors = $validator->errors(); $first = $errors->getMessages(); return response()->json([ 'status' => false, 'message' => (reset($first))[0], 'errors' => $errors ], Response::HTTP_UNPROCESSABLE_ENTITY); } DB::connection()->beginTransaction(); try { $data = SalaryAndWages::create($request->all()); DB::connection()->commit(); return response()->json([ 'message' => 'Record Successfully added!', 'status' => 'success', ],201); } catch (Throwable $e) { DB::connection()->rollback(); return response()->json([ 'status' => false, 'message' => 'Unable to process request. Please try again.', 'data' => $e->getMessage() ]); } } } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings